SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 53086: The %TKMI_JOB_RO waitfor_est_service parameter generates the error "java.io.IOException: Server returned HTTP response code: 500 for URL..."

DetailsHotfixAboutRate It

SAS® Revenue Optimization might generate the following error in the DDMMMYYYY_HH_MM_SS_STATUS.log file.

   Task Name: waitfor_est_service Start Time:DDMMMYYYY:HH:MM:ss.ss
   Task Name: waitfor_est_service Parent log: tmp-log-location/DDMMMYYYY_HH_MM_SS_waitfor_est_service.log
         ERROR: java.io.IOException: Server returned HTTP response code: 500 for URL: http://grid-server-host:port/miserver/services/DataService
         ERROR: FAILURE OF Task Name waitfor_est_service
   Task Name: waitfor_est_service End Time:DDMMMYYYY:HH:MM:ss.ss

This is a generic error that indicates a problem with the estimation run. The only error that is generated in the MerchIntelGridSvr.log file for the estimation run is the following:

YYYY-MM-DD HH:MM:SS,MMM [pool-n-thread-n;] DEBUG - STDOUT: ERRORs detected during tkmi_run (rc=-1)
YYYY-MM-DD HH:MM:SS,MMM [pool-n-thread-n] DEBUG - STDOUT: rc=255
YYYY-MM-DD HH:MM:SS,MMM [pool-n-thread-n] DEBUG - RC: 0
YYYY-MM-DD HH:MM:SS,MMM [pool-n-thread-n] ERROR - Error in TKMIWorker
java.lang.RuntimeException: error (RC=255) on host 'grid-server host-name' while executing remote shell command 'set -o pipefail
(
umask 000
export 'TKPATH=SASHOME/SASFoundation/9.3/sasexe:SASHOME/SASFoundation/9.3/utilities/bin'
export ORACLE_HOME=Oracle-home
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME:$LD_LIBRARY_PATH
export LANG=en_US.UTF-8
export _LANG=en_US.UTF-8
unset LC_ALL
unset NLS_LANG
SASHOME/SASFoundation/9.3/utilities/bin/mi <<END
run=batch_est;partition_id=parition_IDs;host-name_ovrd=captain;scheduled_flg=scheduling_group_num;debug=0; 
preestcleanup=0;.;data=di_dm;status_log_file=captain.status.log;rdbms_vendor=oracle;
rdbms_database=oracle-host:port;/di_dm;rdbms_schema=DIDMROUTF8;rdbms_user=didmroutf8;
rdbms_password=password;debug=0;trace=;
END
) | tee captain.batch_est.log':

	at com.sas.solutions.di.tkmiserver.shell.RemoteShell.exec(RemoteShell.java:128)
	at com.sas.solutions.di.tkmiserver.dispatcher.RshDispatcher.run(RshDispatcher.java:34)
	at com.sas.solutions.di.tkmiserver.CommandHelper.runRshCmd(CommandHelper.java:850)
	at com.sas.solutions.di.tkmiserver.data.DataServiceImpl$TKMIWorker.run(DataServiceImpl.java:1636)
	at com.sas.solutions.di.tkmiserver.data.DataServiceImpl$EstimationWorker.run(DataServiceImpl.java:2049)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)

This error occurs when one of the partitions has no model groups to process. There are no model groups to process in a partition when one of the following is true:

  • There are no model groups in the partition.
  • The %TKMI_JOB_RO SCHEDULING_GROUP_NUM parameter identifies a set of model groups that are in a subset of the partitions.

This error can be ignored because the model groups that are selected for processing complete normally.

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Markdown OptimizationMicrosoft® Windows® for x645.2_M45.49.3 TS1M29.4 TS1M4
Linux for x645.2_M45.49.3 TS1M29.4 TS1M4
SAS SystemSAS Promotion OptimizationMicrosoft® Windows® for x645.2_M45.49.3 TS1M29.4 TS1M4
Linux for x645.2_M45.49.3 TS1M29.4 TS1M4
SAS SystemSAS Regular Price OptimizationMicrosoft® Windows® for x645.2_M45.49.3 TS1M29.4 TS1M4
Linux for x645.2_M45.49.3 TS1M29.4 TS1M4
SAS SystemSAS Retail ForecastingMicrosoft® Windows® for x645.2_M49.3 TS1M2
Linux for x645.2_M49.3 TS1M2
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.